Today is February 29th. An unique date which we only get to observe once every four year. Year 2012 is leap year and SQL Server 2012 is also releasing this year. Yesterday I wrote an article where we have seen observed how using four different function we can create another function which can accurately validate [...]
I get some strange looks from people when they see what machines I use in my DBA life. First it was because I was using a personal MacBook Pro. In the past few days, it’s because I’m not using it any longer. I still love the MBP, but so does my wife, and she, rightfully, didn’t love the idea that I was hogging it all the time. Now the MBP has returned to its quiet life at home, and I have a new Tablet with a touch UI for work. That was a huge change for me, because it’s the first PC I’ve ever bought....(read more)
A long, long time ago in a galaxy you can reach out and touch right now, ORDER BY in a VIEW meant something. If you had a view like the following: CREATE VIEW dbo.Rubbish AS SELECT TOP 100 PERCENT Trash FROM dbo.Garbage ORDER BY Trash ; And then you ran a query such as: SELECT Trash FROM dbo.Rubbish ; You could reliably expect the rows to come back ordered by Trash in ascending order, even though it is relatively clear that the ORDER BY here serves a completely different and overloaded purpose -...(read more)
THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Maria Zakourdaev Entire Site Search Home Blogs Downloads Opml Maria Zakourdaev The only thing worse than being talked about is not being talked about . Oscar Wilde Unfairly forgotten partitioning views can help us make our partitioning tables design better Partitioning is a very important feature for scalable applications , it allows breaking up huge monolithic tables in order to ensure their scalability manageability within a single instance . For example , data deletion and loading can be very fast if done by partition . Reorganizing , optimizing and rebuilding indices also can be done by partition which is much less intrusive and . faster Also , when talking about
Note: Tomorrow is February 29th. This blog post is dedicated to coming tomorrow – a special day :) Subu: “How can I find leap year in using SQL Server 2012?“ Pinal: “Are you asking me how to year 2012 is leap year using T-SQL – search online and you will find many example of the [...]
THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in SQLBI Marco Russo Entire Site Search Home Blogs Downloads Opml SQLBI Marco Russo SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server Create a dax Measure in a Session in BISM Tabular Thanks to Greg Galloway that pointed me out this is possible , in this post I want to show how to create a measure local to a session . This could be done in SQL Server Management Studio , even if it is probably not so useful for a Tabular model considering that you can easily define measures local to a DAX query . However , maybe you will have a reason to do that I can only imagine a long list of measures defined in a session that are used in small queries sent
If you are following my recent blog posts, you may have noticed that I’ve been writing a lot about Guest User in SQL Server. Here are all the blog posts which I have written on this subject: SQL SERVER – Disable Guest Account – Serious Security Issue SQL SERVER – Force Removing User from Database – [...]
I have been working with SQL Server for more than 8 years now continuously and I like to read a lot. Some time I read easy things and sometime I read stuff which are not so easy. Here are few recently released article which I referred and read. They are not easy read but indeed [...]
“I do not know where my windows went!” “I just closed my object explorer and now I cannot find it.” “How do I get my original windows layout back in SQL Server Management Studio?” “How do I get the window which was there in left side back again?” Since last 2-3 years, every single day [...]I have written a few articles recently on the subject of guest account. Here’s a quick list of these articles: SQL SERVER – Disable Guest Account – Serious Security Issue SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in. SQL SERVER – Detecting [...]
Earlier I wrote the blog post SQL SERVER – Disable Guest Account – Serious Security Issue, and I got many comments asking questions related to the guest user. Here are the comments of Manoj: 1) How do we know if the uest user is enabled or disabled? 2) What is the default for guest user in SQL Server? [...]
THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in SSIS Junkie Entire Site Search Home Blogs Forums Downloads Opml SSIS Junkie Freelance SQL Server developer in London Variable enhancements in RC0 SSIS I have been poking around idly in the RC0 release of SQL Server Integration Services SSIS 2012 and noticed a few nice enhancements that hadn’t really hit the newsstands as yet well , I didn’t know about them anyway Here is a quick : rundown Expression is viewable in the Variables window Fairly self-explanatory this one . If a variable has an expression applied to it that expression can now be seen in the Variables window also notice that the variable icon gets an adorner specifying that there is an expression upon it . What isWe got tremendous response to our very first video of SQL in Sixty Seconds #001 and SQL in Sixty Seconds #002. We talked about how to convert Subquery to CTE and Error and Reaction. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we believe would be helpful to [...]
Yesterday I wrote a blog post discussing how guest user can become security threat. The script which was demonstrated for the example had a small T-SQL query which creates a new user. Later, I got an email from a user who had created this scenario on his production environment. It makes me sad that I [...]
“No Guests PLEASE!” “Doesn’t your Indian tradition suggest welcoming guests and treating them in the best way possible?” “Yes, but I am talking about the Guest user in SQL Server.” “Oh!” This was a real conversation that happened a couple of years ago. I welcome guests as much as any other Indian does; however, I am strongly opinionated about [...]
Migration is always the challenge, it does not matter if people are migrating from one country to another country or birds are migrating from one continent to another continent or database is migrating from one platform to another platform. I remember years ago when I had to migrate our database from another platform to SQL Server, [...]Jeff asked me another question! If you do not know Jeff, you may read the following blog posts. You will get the idea of Jeff’s personality and who Jeff really is. SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2 SQL SERVER – INNER JOIN Returning More Records than Exists in [...]
THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Extended Events Entire Site Search Home Blogs Forums Downloads Opml Extended Events Issues with the system_health session in SQL Server 2012 The ever alert Jonathan Kehayias Blog Twitter sent me a question recently asking about the Extended Event UI used for showing predicates . In particular , he was wondering about the predicate for the wait_info event that is defined in the system_health session and was wondering what was going . on It’s obvious what peaked Jonathan’s interest all those error icons seem like there is a problem with the predicate . This post will explain what’s happening , why it’s happening and also document a problem that I discovered while investigatingSome questions are timeless and they never grow old; no matter how much they grow old their interest never dies. Earlier, I asked a simple puzzle based on a conversation on SQLAuthority Page, and have received an overwhelming response from readers. I still get emails related to this puzzle every day. Before we move on, I suggest you [...]We got tremendous response to our very first video of SQL in Sixty Seconds #001. We talked about how to convert Subquery to CTE very quickly. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we believe would be helpful to readers. In today’s SQL in Sixty [...]
Decoding the human genome originally took 10 years to process; now it can be achieved in one week - The Economist. This blog post is written in response to the T-SQL Tuesday post of The Big Data. This is a very interesting subject. Data is growing every single day. I remember my first computer which had [...]“I have text files and I need to create interactive reports for my boss – do you have few minutes of time right now? Let us discuss.” I often get questions from people who are new to technology and struggling to get something done. However, this time it was not a question from any beginner. [...]
I am in front of computer 16+ hours of the day. However, I accept that I am bit lazy when it is about doing installation etc. I always prefer that IT department help me to install my computer and I use it right away. Same feeling I get when I have to install Beta, RC [...]
Yesterday was really fun. I asked a simple Brain Teaser and we had excellent conversation on SQLAuthority Page as well SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser. That was an easy puzzle for those who have attended the SQL Server Questions and Answers online course. Here is a quick recap of the puzzle. Lots [...]
It seems that we all love to solve puzzles. On SQLAuthority Page, we have been playing the number game and those who are playing with us know how much fun we are having. Sometimes, the answers are so innovative and informative that they open up those aspects of the technology which I have not thought [...]
I blog and engage with the community because it gives me satisfaction when someone resolves an issue. A few days ago, I blogged about a DBA who began his first day at a new company and could not find out where the installation summary file was. He was very happy when I featured his story [...]SQL Server is an ocean of information. I believe if one starts learning today, after 60 years he/she may still be learning the subject (there are always a few exceptions)! Recently, I published the SQL Server Questions and Answers video tutorial, and since the course came out, I have been receiving lots of request to [...]Here is email received from user: “Pinal, I am new DBA in my organization and I have to manage SQL Server 2005, 2008 and 2008 R2. Today is my first day at job and my manager has asked me to install all these different edition on our test environment. I have finished installing them. Later [...]
Recently one of my friend sent me email that he is having some problem with his very small database. We talked for few minutes and we agreed that to further investigation I will need access to the whole database. As the database was very big he dropped it in common location (you can use livemesh [...]SQL Server 2012 is has very exciting new feature of SQL Server AlwaysOn. This new feature reduces planned and unplanned downtime and maximize application available. Additionally it provides data protection keeping database always available. Microsoft has released a whitepaper on this subject where it discusses common context business stakeholders, technical decision makers, system architects, infrastructure [...]